package lily.phs.object;

import lily.phs.database.Constants;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;


public class FirstPrenatalVisit implements Constants{
	
	private Context mContext;
	
	private int fipv_id=-1;
	private String fipv_date="";
	private int fipv_preg_week=-1;
	private int fipv_age=-1;
	private String fipv_husband_name="";
	private int fipv_husband_age=-1;
	private String fipv_husband_phone="";
	private int fipv_gravidity=-1;
	private int fipv_vaginal_delivery_times=-1;
	private int fipv_cesarean_section_times=-1;
	private int fipv_last_menses=-1;
	private String fipv_last_menses_date="";
	private String fipv_ycq="";
	private String fipv_past_history="";
	private String fipv_past_history_other="";
	private String fipv_family="";
	private String fipv_family_other="";
	private String fipv_personal="";
	private String fipv_personal_other="";
	private int fipv_has_gyneopration=-1;
	private String fipv_gyneopration="";
	private String fipv_pregnance_history="";
	private int fipv_miscarry=-1;
	private int fipv_dying_fetus=-1;
	private int fipv_stillbirth=-1;
	private int fipv_neonatal_death=-1;
	private int fipv_birth_defect=-1;
	private int fipv_height=-1;
	private float fipv_weight=-1f;
	private float fipv_bmt=-1f;
	private int fipv_bloodpressure_high=-1;
	private int fipv_bloodpressure_low=-1;
	private int fipv_has_heart_abnormal=-1;
	private String fipv_heart_abnormal="";
	private int fipv_has_lung_abnormal=-1;
	private String fipv_lung_abnormal="";
	private int fipv_has_vulva_abnormal=-1;
	private String fipv_vulva_abnormal="";
	private int fipv_has_vagina_abnormal=-1;
	private String fipv_vagina_abnormal="";
	private int fipv_has_cervix_abnormal=-1;
	private String fipv_cervix_abnormal="";
	private int fipv_has_uterus_abnormal=-1;
	private String fipv_uterus_abnormal="";
	private int fipv_has_appendix_abnormal=-1;
	private String fipv_appendix_abnormal="";
	private float fipv_hemoglobin=-1f;
	private float fipv_wbc=-1f;
	private float fipv_blood_platelet=-1f;
	private float fipv_blood_other=-1f;
	private float fipv_pro=-1f;
	private float fipv_glu=-1f;
	private float fipv_urine_ketone=-1f;
	private float fipv_bld=-1f;
	private float fipv_urine_other=-1f;
	private String fipv_blood_type="";
	private String fipv_blood_rh="";
	private float fipv_bs=-1f;
	private float fipv_serum_cpt=-1f;
	private float fipv_serum_ast=-1f;
	private float fipv_blood_protein=-1f;
	private float fipv_tbil=-1f;
	private float fipv_dbil=-1f;
	private float fipv_serum_creatinine=-1f;
	private float fipv_bun=-1f;
	private String fipv_vaginal_discharge="";
	private String fipv_vaginal_other_discharge="";
	private int fipv_vagina_cleanness=-1;
	private String fipv_surface_antigen="";
	private String fipv_surface_antibody="";
	private String fipv_e_antigen="";
	private String fipv_e_antibody="";
	private String fipv_core_antibody="";
	private int fipv_syphilis_sero_test=-1;
	private int fipv_hiv_test=-1;
	private String fipv_brightness_mode="";
	private int fipv_overall_access=-1;
	private String fipv_overall_access_abnormal="";
	private String fipv_healthguide="";
	private String fipv_healthguide_other="";
	private int fipv_need_transfer=-1;
	private String fipv_transfer_reason="";
	private String fipv_transfer_hospital="";
	private String fipv_next_visit_date="";
	private String fipv_doctor="";
	
	public FirstPrenatalVisit(Context context){
		this.mContext = context;
	}

	public int getFipv_id() {
		return fipv_id;
	}

	public void setFipv_id(int fipv_id) {
		this.fipv_id = fipv_id;
	}

	public String getFipv_date() {
		return fipv_date;
	}

	public void setFipv_date(String fipv_date) {
		this.fipv_date = fipv_date;
	}

	public int getFipv_preg_week() {
		return fipv_preg_week;
	}

	public void setFipv_preg_week(int fipv_preg_week) {
		this.fipv_preg_week = fipv_preg_week;
	}

	public int getFipv_age() {
		return fipv_age;
	}

	public void setFipv_age(int fipv_age) {
		this.fipv_age = fipv_age;
	}

	public String getFipv_husband_name() {
		return fipv_husband_name;
	}

	public void setFipv_husband_name(String fipv_husband_name) {
		this.fipv_husband_name = fipv_husband_name;
	}

	public int getFipv_husband_age() {
		return fipv_husband_age;
	}

	public void setFipv_husband_age(int fipv_husband_age) {
		this.fipv_husband_age = fipv_husband_age;
	}

	public String getFipv_husband_phone() {
		return fipv_husband_phone;
	}

	public void setFipv_husband_phone(String fipv_husband_phone) {
		this.fipv_husband_phone = fipv_husband_phone;
	}

	public int getFipv_gravidity() {
		return fipv_gravidity;
	}

	public void setFipv_gravidity(int fipv_gravidity) {
		this.fipv_gravidity = fipv_gravidity;
	}

	public int getFipv_vaginal_delivery_times() {
		return fipv_vaginal_delivery_times;
	}

	public void setFipv_vaginal_delivery_times(int fipv_vaginal_delivery_times) {
		this.fipv_vaginal_delivery_times = fipv_vaginal_delivery_times;
	}

	public int getFipv_cesarean_section_times() {
		return fipv_cesarean_section_times;
	}

	public void setFipv_cesarean_section_times(int fipv_cesarean_section_times) {
		this.fipv_cesarean_section_times = fipv_cesarean_section_times;
	}

	public int getFipv_last_menses() {
		return fipv_last_menses;
	}

	public void setFipv_last_menses(int fipv_last_menses) {
		this.fipv_last_menses = fipv_last_menses;
	}

	public String getFipv_last_menses_date() {
		return fipv_last_menses_date;
	}

	public void setFipv_last_menses_date(String fipv_last_menses_date) {
		this.fipv_last_menses_date = fipv_last_menses_date;
	}

	public String getFipv_ycq() {
		return fipv_ycq;
	}

	public void setFipv_ycq(String fipv_ycq) {
		this.fipv_ycq = fipv_ycq;
	}

	public String getFipv_past_history() {
		return fipv_past_history;
	}

	public void setFipv_past_history(String fipv_past_history) {
		this.fipv_past_history = fipv_past_history;
	}

	public String getFipv_past_history_other() {
		return fipv_past_history_other;
	}

	public void setFipv_past_history_other(String fipv_past_history_other) {
		this.fipv_past_history_other = fipv_past_history_other;
	}

	public String getFipv_family() {
		return fipv_family;
	}

	public void setFipv_family(String fipv_family) {
		this.fipv_family = fipv_family;
	}

	public String getFipv_family_other() {
		return fipv_family_other;
	}

	public void setFipv_family_other(String fipv_family_other) {
		this.fipv_family_other = fipv_family_other;
	}

	public String getFipv_personal() {
		return fipv_personal;
	}

	public void setFipv_personal(String fipv_personal) {
		this.fipv_personal = fipv_personal;
	}

	public String getFipv_personal_other() {
		return fipv_personal_other;
	}

	public void setFipv_personal_other(String fipv_personal_other) {
		this.fipv_personal_other = fipv_personal_other;
	}

	public int getFipv_has_gyneopration() {
		return fipv_has_gyneopration;
	}

	public void setFipv_has_gyneopration(int fipv_has_gyneopration) {
		this.fipv_has_gyneopration = fipv_has_gyneopration;
	}

	public String getFipv_gyneopration() {
		return fipv_gyneopration;
	}

	public void setFipv_gyneopration(String fipv_gyneopration) {
		this.fipv_gyneopration = fipv_gyneopration;
	}

	public String getFipv_pregnance_history() {
		return fipv_pregnance_history;
	}

	public void setFipv_pregnance_history(String fipv_pregnance_history) {
		this.fipv_pregnance_history = fipv_pregnance_history;
	}

	public int getFipv_miscarry() {
		return fipv_miscarry;
	}

	public void setFipv_miscarry(int fipv_miscarry) {
		this.fipv_miscarry = fipv_miscarry;
	}

	public int getFipv_dying_fetus() {
		return fipv_dying_fetus;
	}

	public void setFipv_dying_fetus(int fipv_dying_fetus) {
		this.fipv_dying_fetus = fipv_dying_fetus;
	}

	public int getFipv_stillbirth() {
		return fipv_stillbirth;
	}

	public void setFipv_stillbirth(int fipv_stillbirth) {
		this.fipv_stillbirth = fipv_stillbirth;
	}

	public int getFipv_neonatal_death() {
		return fipv_neonatal_death;
	}

	public void setFipv_neonatal_death(int fipv_neonatal_death) {
		this.fipv_neonatal_death = fipv_neonatal_death;
	}

	public int getFipv_birth_defect() {
		return fipv_birth_defect;
	}

	public void setFipv_birth_defect(int fipv_birth_defect) {
		this.fipv_birth_defect = fipv_birth_defect;
	}

	public int getFipv_height() {
		return fipv_height;
	}

	public void setFipv_height(int fipv_height) {
		this.fipv_height = fipv_height;
	}

	public float getFipv_weight() {
		return fipv_weight;
	}

	public void setFipv_weight(float fipv_weight) {
		this.fipv_weight = fipv_weight;
	}

	public float getFipv_bmt() {
		return fipv_bmt;
	}

	public void setFipv_bmt(float fipv_bmt) {
		this.fipv_bmt = fipv_bmt;
	}

	public int getFipv_bloodpressure_high() {
		return fipv_bloodpressure_high;
	}

	public void setFipv_bloodpressure_high(int fipv_bloodpressure_high) {
		this.fipv_bloodpressure_high = fipv_bloodpressure_high;
	}

	public int getFipv_bloodpressure_low() {
		return fipv_bloodpressure_low;
	}

	public void setFipv_bloodpressure_low(int fipv_bloodpressure_low) {
		this.fipv_bloodpressure_low = fipv_bloodpressure_low;
	}

	public int getFipv_has_heart_abnormal() {
		return fipv_has_heart_abnormal;
	}

	public void setFipv_has_heart_abnormal(int fipv_has_heart_abnormal) {
		this.fipv_has_heart_abnormal = fipv_has_heart_abnormal;
	}

	public String getFipv_heart_abnormal() {
		return fipv_heart_abnormal;
	}

	public void setFipv_heart_abnormal(String fipv_heart_abnormal) {
		this.fipv_heart_abnormal = fipv_heart_abnormal;
	}

	public int getFipv_has_lung_abnormal() {
		return fipv_has_lung_abnormal;
	}

	public void setFipv_has_lung_abnormal(int fipv_has_lung_abnormal) {
		this.fipv_has_lung_abnormal = fipv_has_lung_abnormal;
	}

	public String getFipv_lung_abnormal() {
		return fipv_lung_abnormal;
	}

	public void setFipv_lung_abnormal(String fipv_lung_abnormal) {
		this.fipv_lung_abnormal = fipv_lung_abnormal;
	}

	public int getFipv_has_vulva_abnormal() {
		return fipv_has_vulva_abnormal;
	}

	public void setFipv_has_vulva_abnormal(int fipv_has_vulva_abnormal) {
		this.fipv_has_vulva_abnormal = fipv_has_vulva_abnormal;
	}

	public String getFipv_vulva_abnormal() {
		return fipv_vulva_abnormal;
	}

	public void setFipv_vulva_abnormal(String fipv_vulva_abnormal) {
		this.fipv_vulva_abnormal = fipv_vulva_abnormal;
	}

	public int getFipv_has_vagina_abnormal() {
		return fipv_has_vagina_abnormal;
	}

	public void setFipv_has_vagina_abnormal(int fipv_has_vagina_abnormal) {
		this.fipv_has_vagina_abnormal = fipv_has_vagina_abnormal;
	}

	public String getFipv_vagina_abnormal() {
		return fipv_vagina_abnormal;
	}

	public void setFipv_vagina_abnormal(String fipv_vagina_abnormal) {
		this.fipv_vagina_abnormal = fipv_vagina_abnormal;
	}

	public int getFipv_has_cervix_abnormal() {
		return fipv_has_cervix_abnormal;
	}

	public void setFipv_has_cervix_abnormal(int fipv_has_cervix_abnormal) {
		this.fipv_has_cervix_abnormal = fipv_has_cervix_abnormal;
	}

	public String getFipv_cervix_abnormal() {
		return fipv_cervix_abnormal;
	}

	public void setFipv_cervix_abnormal(String fipv_cervix_abnormal) {
		this.fipv_cervix_abnormal = fipv_cervix_abnormal;
	}

	public int getFipv_has_uterus_abnormal() {
		return fipv_has_uterus_abnormal;
	}

	public void setFipv_has_uterus_abnormal(int fipv_has_uterus_abnormal) {
		this.fipv_has_uterus_abnormal = fipv_has_uterus_abnormal;
	}

	public String getFipv_uterus_abnormal() {
		return fipv_uterus_abnormal;
	}

	public void setFipv_uterus_abnormal(String fipv_uterus_abnormal) {
		this.fipv_uterus_abnormal = fipv_uterus_abnormal;
	}

	public int getFipv_has_appendix_abnormal() {
		return fipv_has_appendix_abnormal;
	}

	public void setFipv_has_appendix_abnormal(int fipv_has_appendix_abnormal) {
		this.fipv_has_appendix_abnormal = fipv_has_appendix_abnormal;
	}

	public String getFipv_appendix_abnormal() {
		return fipv_appendix_abnormal;
	}

	public void setFipv_appendix_abnormal(String fipv_appendix_abnormal) {
		this.fipv_appendix_abnormal = fipv_appendix_abnormal;
	}

	public float getFipv_hemoglobin() {
		return fipv_hemoglobin;
	}

	public void setFipv_hemoglobin(float fipv_hemoglobin) {
		this.fipv_hemoglobin = fipv_hemoglobin;
	}

	public float getFipv_wbc() {
		return fipv_wbc;
	}

	public void setFipv_wbc(float fipv_wbc) {
		this.fipv_wbc = fipv_wbc;
	}

	public float getFipv_blood_platelet() {
		return fipv_blood_platelet;
	}

	public void setFipv_blood_platelet(float fipv_blood_platelet) {
		this.fipv_blood_platelet = fipv_blood_platelet;
	}

	public float getFipv_blood_other() {
		return fipv_blood_other;
	}

	public void setFipv_blood_other(float fipv_blood_other) {
		this.fipv_blood_other = fipv_blood_other;
	}

	public float getFipv_pro() {
		return fipv_pro;
	}

	public void setFipv_pro(float fipv_pro) {
		this.fipv_pro = fipv_pro;
	}

	public float getFipv_glu() {
		return fipv_glu;
	}

	public void setFipv_glu(float fipv_glu) {
		this.fipv_glu = fipv_glu;
	}

	public float getFipv_urine_ketone() {
		return fipv_urine_ketone;
	}

	public void setFipv_urine_ketone(float fipv_urine_ketone) {
		this.fipv_urine_ketone = fipv_urine_ketone;
	}

	public float getFipv_bld() {
		return fipv_bld;
	}

	public void setFipv_bld(float fipv_bld) {
		this.fipv_bld = fipv_bld;
	}

	public float getFipv_urine_other() {
		return fipv_urine_other;
	}

	public void setFipv_urine_other(float fipv_urine_other) {
		this.fipv_urine_other = fipv_urine_other;
	}

	public String getFipv_blood_type() {
		return fipv_blood_type;
	}

	public void setFipv_blood_type(String fipv_blood_type) {
		this.fipv_blood_type = fipv_blood_type;
	}

	public String getFipv_blood_rh() {
		return fipv_blood_rh;
	}

	public void setFipv_blood_rh(String fipv_blood_rh) {
		this.fipv_blood_rh = fipv_blood_rh;
	}

	public float getFipv_bs() {
		return fipv_bs;
	}

	public void setFipv_bs(float fipv_bs) {
		this.fipv_bs = fipv_bs;
	}

	public float getFipv_serum_cpt() {
		return fipv_serum_cpt;
	}

	public void setFipv_serum_cpt(float fipv_serum_cpt) {
		this.fipv_serum_cpt = fipv_serum_cpt;
	}

	public float getFipv_serum_ast() {
		return fipv_serum_ast;
	}

	public void setFipv_serum_ast(float fipv_serum_ast) {
		this.fipv_serum_ast = fipv_serum_ast;
	}

	public float getFipv_blood_protein() {
		return fipv_blood_protein;
	}

	public void setFipv_blood_protein(float fipv_blood_protein) {
		this.fipv_blood_protein = fipv_blood_protein;
	}

	public float getFipv_tbil() {
		return fipv_tbil;
	}

	public void setFipv_tbil(float fipv_tbil) {
		this.fipv_tbil = fipv_tbil;
	}

	public float getFipv_dbil() {
		return fipv_dbil;
	}

	public void setFipv_dbil(float fipv_dbil) {
		this.fipv_dbil = fipv_dbil;
	}

	public float getFipv_serum_creatinine() {
		return fipv_serum_creatinine;
	}

	public void setFipv_serum_creatinine(float fipv_serum_creatinine) {
		this.fipv_serum_creatinine = fipv_serum_creatinine;
	}

	public float getFipv_bun() {
		return fipv_bun;
	}

	public void setFipv_bun(float fipv_bun) {
		this.fipv_bun = fipv_bun;
	}

	public String getFipv_vaginal_discharge() {
		return fipv_vaginal_discharge;
	}

	public void setFipv_vaginal_discharge(String fipv_vaginal_discharge) {
		this.fipv_vaginal_discharge = fipv_vaginal_discharge;
	}

	public String getFipv_vaginal_other_discharge() {
		return fipv_vaginal_other_discharge;
	}

	public void setFipv_vaginal_other_discharge(String fipv_vaginal_other_discharge) {
		this.fipv_vaginal_other_discharge = fipv_vaginal_other_discharge;
	}

	public int getFipv_vagina_cleanness() {
		return fipv_vagina_cleanness;
	}

	public void setFipv_vagina_cleanness(int fipv_vagina_cleanness) {
		this.fipv_vagina_cleanness = fipv_vagina_cleanness;
	}

	public String getFipv_surface_antigen() {
		return fipv_surface_antigen;
	}

	public void setFipv_surface_antigen(String fipv_surface_antigen) {
		this.fipv_surface_antigen = fipv_surface_antigen;
	}

	public String getFipv_surface_antibody() {
		return fipv_surface_antibody;
	}

	public void setFipv_surface_antibody(String fipv_surface_antibody) {
		this.fipv_surface_antibody = fipv_surface_antibody;
	}

	public String getFipv_e_antigen() {
		return fipv_e_antigen;
	}

	public void setFipv_e_antigen(String fipv_e_antigen) {
		this.fipv_e_antigen = fipv_e_antigen;
	}

	public String getFipv_e_antibody() {
		return fipv_e_antibody;
	}

	public void setFipv_e_antibody(String fipv_e_antibody) {
		this.fipv_e_antibody = fipv_e_antibody;
	}

	public String getFipv_core_antibody() {
		return fipv_core_antibody;
	}

	public void setFipv_core_antibody(String fipv_core_antibody) {
		this.fipv_core_antibody = fipv_core_antibody;
	}

	public int getFipv_syphilis_sero_test() {
		return fipv_syphilis_sero_test;
	}

	public void setFipv_syphilis_sero_test(int fipv_syphilis_sero_test) {
		this.fipv_syphilis_sero_test = fipv_syphilis_sero_test;
	}

	public int getFipv_hiv_test() {
		return fipv_hiv_test;
	}

	public void setFipv_hiv_test(int fipv_hiv_test) {
		this.fipv_hiv_test = fipv_hiv_test;
	}

	public String getFipv_brightness_mode() {
		return fipv_brightness_mode;
	}

	public void setFipv_brightness_mode(String fipv_brightness_mode) {
		this.fipv_brightness_mode = fipv_brightness_mode;
	}

	public int getFipv_overall_access() {
		return fipv_overall_access;
	}

	public void setFipv_overall_access(int fipv_overall_access) {
		this.fipv_overall_access = fipv_overall_access;
	}

	public String getFipv_overall_access_abnormal() {
		return fipv_overall_access_abnormal;
	}

	public void setFipv_overall_access_abnormal(String fipv_overall_access_abnormal) {
		this.fipv_overall_access_abnormal = fipv_overall_access_abnormal;
	}

	public String getFipv_healthguide() {
		return fipv_healthguide;
	}

	public void setFipv_healthguide(String fipv_healthguide) {
		this.fipv_healthguide = fipv_healthguide;
	}

	public String getFipv_healthguide_other() {
		return fipv_healthguide_other;
	}

	public void setFipv_healthguide_other(String fipv_healthguide_other) {
		this.fipv_healthguide_other = fipv_healthguide_other;
	}

	public int getFipv_need_transfer() {
		return fipv_need_transfer;
	}

	public void setFipv_need_transfer(int fipv_need_transfer) {
		this.fipv_need_transfer = fipv_need_transfer;
	}

	public String getFipv_transfer_reason() {
		return fipv_transfer_reason;
	}

	public void setFipv_transfer_reason(String fipv_transfer_reason) {
		this.fipv_transfer_reason = fipv_transfer_reason;
	}

	public String getFipv_transfer_hospital() {
		return fipv_transfer_hospital;
	}

	public void setFipv_transfer_hospital(String fipv_transfer_hospital) {
		this.fipv_transfer_hospital = fipv_transfer_hospital;
	}

	public String getFipv_next_visit_date() {
		return fipv_next_visit_date;
	}

	public void setFipv_next_visit_date(String fipv_next_visit_date) {
		this.fipv_next_visit_date = fipv_next_visit_date;
	}

	public String getFipv_doctor() {
		return fipv_doctor;
	}

	public void setFipv_doctor(String fipv_doctor) {
		this.fipv_doctor = fipv_doctor;
	}
	
	public void insertFirstPrenatalVisit(){
//		int result = -1;
		ContentValues value = new ContentValues();
		value.put(FIPV_COLUMN1, this.getFipv_id());
		value.put(FIPV_COLUMN2, this.getFipv_date());
		value.put(FIPV_COLUMN3, this.getFipv_preg_week());
		value.put(FIPV_COLUMN4, this.getFipv_age());
		value.put(FIPV_COLUMN5, this.getFipv_husband_name());
		value.put(FIPV_COLUMN6, this.getFipv_husband_age());
		value.put(FIPV_COLUMN7, this.getFipv_husband_phone());
		value.put(FIPV_COLUMN8, this.getFipv_gravidity());
		value.put(FIPV_COLUMN9, this.getFipv_vaginal_delivery_times());
		value.put(FIPV_COLUMN10, this.getFipv_cesarean_section_times());
		value.put(FIPV_COLUMN11, this.getFipv_last_menses());
		value.put(FIPV_COLUMN12, this.getFipv_last_menses_date());
		value.put(FIPV_COLUMN13, this.getFipv_ycq());
		value.put(FIPV_COLUMN14, this.getFipv_past_history());
		value.put(FIPV_COLUMN15, this.getFipv_past_history_other());
		value.put(FIPV_COLUMN16, this.getFipv_family());
		value.put(FIPV_COLUMN17, this.getFipv_family_other());
		value.put(FIPV_COLUMN18, this.getFipv_personal());
		value.put(FIPV_COLUMN19, this.getFipv_personal_other());
		value.put(FIPV_COLUMN20, this.getFipv_has_gyneopration());
		value.put(FIPV_COLUMN21, this.getFipv_gyneopration());
		value.put(FIPV_COLUMN85, this.getFipv_pregnance_history());
		value.put(FIPV_COLUMN22, this.getFipv_miscarry());
		value.put(FIPV_COLUMN23, this.getFipv_dying_fetus());
		value.put(FIPV_COLUMN24, this.getFipv_stillbirth());
		value.put(FIPV_COLUMN25, this.getFipv_neonatal_death());
		value.put(FIPV_COLUMN26, this.getFipv_birth_defect());
		value.put(FIPV_COLUMN27, this.getFipv_height());
		value.put(FIPV_COLUMN28, this.getFipv_weight());
		value.put(FIPV_COLUMN29, this.getFipv_bmt());
		value.put(FIPV_COLUMN30, this.getFipv_bloodpressure_high());
		value.put(FIPV_COLUMN31, this.getFipv_bloodpressure_low());
		value.put(FIPV_COLUMN32, this.getFipv_has_heart_abnormal());
		value.put(FIPV_COLUMN33, this.getFipv_heart_abnormal());
		value.put(FIPV_COLUMN34, this.getFipv_has_lung_abnormal());
		value.put(FIPV_COLUMN35, this.getFipv_lung_abnormal());
		value.put(FIPV_COLUMN36, this.getFipv_has_vulva_abnormal());
		value.put(FIPV_COLUMN37, this.getFipv_vulva_abnormal());
		value.put(FIPV_COLUMN38, this.getFipv_has_vagina_abnormal());
		value.put(FIPV_COLUMN39, this.getFipv_vagina_abnormal());
		value.put(FIPV_COLUMN40, this.getFipv_has_cervix_abnormal());
		value.put(FIPV_COLUMN41, this.getFipv_cervix_abnormal());
		value.put(FIPV_COLUMN42, this.getFipv_has_uterus_abnormal());
		value.put(FIPV_COLUMN43, this.getFipv_uterus_abnormal());
		value.put(FIPV_COLUMN44, this.getFipv_has_appendix_abnormal());
		value.put(FIPV_COLUMN45, this.getFipv_appendix_abnormal());
		value.put(FIPV_COLUMN46, this.getFipv_hemoglobin());
		value.put(FIPV_COLUMN47, this.getFipv_wbc());
		value.put(FIPV_COLUMN48, this.getFipv_blood_platelet());
		value.put(FIPV_COLUMN49, this.getFipv_blood_other());
		value.put(FIPV_COLUMN50, this.getFipv_pro());
		value.put(FIPV_COLUMN51, this.getFipv_glu());
		value.put(FIPV_COLUMN52, this.getFipv_urine_ketone());
		value.put(FIPV_COLUMN53, this.getFipv_bld());
		value.put(FIPV_COLUMN54, this.getFipv_urine_other());
		value.put(FIPV_COLUMN55, this.getFipv_blood_type());
		value.put(FIPV_COLUMN56, this.getFipv_blood_rh());
		value.put(FIPV_COLUMN57, this.getFipv_bs());
		value.put(FIPV_COLUMN58, this.getFipv_serum_cpt());
		value.put(FIPV_COLUMN59, this.getFipv_serum_ast());
		value.put(FIPV_COLUMN60, this.getFipv_blood_protein());
		value.put(FIPV_COLUMN61, this.getFipv_tbil());
		value.put(FIPV_COLUMN62, this.getFipv_dbil());
		value.put(FIPV_COLUMN63, this.getFipv_serum_creatinine());
		value.put(FIPV_COLUMN64, this.getFipv_bun());
		value.put(FIPV_COLUMN65, this.getFipv_vaginal_discharge());
		value.put(FIPV_COLUMN66, this.getFipv_vaginal_other_discharge());
		value.put(FIPV_COLUMN67, this.getFipv_vagina_cleanness());
		value.put(FIPV_COLUMN68, this.getFipv_surface_antigen());
		value.put(FIPV_COLUMN69, this.getFipv_surface_antibody());
		value.put(FIPV_COLUMN70, this.getFipv_e_antigen());
		value.put(FIPV_COLUMN71, this.getFipv_e_antibody());
		value.put(FIPV_COLUMN72, this.getFipv_core_antibody());
		value.put(FIPV_COLUMN73, this.getFipv_syphilis_sero_test());
		value.put(FIPV_COLUMN74, this.getFipv_hiv_test());
		value.put(FIPV_COLUMN75, this.getFipv_brightness_mode());
		value.put(FIPV_COLUMN76, this.getFipv_overall_access());
		value.put(FIPV_COLUMN77, this.getFipv_overall_access_abnormal());
		value.put(FIPV_COLUMN78, this.getFipv_healthguide());
		value.put(FIPV_COLUMN79, this.getFipv_healthguide_other());
		value.put(FIPV_COLUMN80, this.getFipv_need_transfer());
		value.put(FIPV_COLUMN81, this.getFipv_transfer_reason());
		value.put(FIPV_COLUMN82, this.getFipv_transfer_hospital());
		value.put(FIPV_COLUMN83, this.getFipv_next_visit_date());
		value.put(FIPV_COLUMN84, this.getFipv_doctor());
		
		mContext.getContentResolver().insert(CONTENT_URI_TB16, value);
//		return result;
		
	}
	
	public void selectFirstPrenatalVisit(int id){
		String where = FIPV_COLUMN1 + "=" + id + "";
		Cursor cursor = mContext.getContentResolver().query(CONTENT_URI_TB16, null, where, null, null);
		while(cursor.moveToNext()){
			this.fipv_id = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN1));
			this.fipv_date = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN2));
			this.fipv_preg_week = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN3));
			this.fipv_age = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN4));
			this.fipv_husband_name = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN5));
			this.fipv_husband_age = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN6));
			this.fipv_husband_phone = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN7));
			this.fipv_gravidity = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN8));
			this.fipv_vaginal_delivery_times = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN9));
			this.fipv_cesarean_section_times = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN10));
			this.fipv_last_menses = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN11));
			this.fipv_last_menses_date = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN12));
			this.fipv_ycq = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN13));
			this.fipv_past_history = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN14));
			this.fipv_past_history_other = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN15));
			this.fipv_family = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN16));
			this.fipv_family_other = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN17));
			this.fipv_personal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN18));
			this.fipv_personal_other = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN19));
			this.fipv_has_gyneopration = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN20));
			this.fipv_gyneopration = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN21));
			this.fipv_pregnance_history = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN85));
			this.fipv_miscarry = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN22));
			this.fipv_dying_fetus = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN23));
			this.fipv_stillbirth = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN24));
			this.fipv_neonatal_death = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN25));
			this.fipv_birth_defect = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN26));
			this.fipv_height = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN27));
			this.fipv_weight = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN28));
			this.fipv_bmt = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN29));
			this.fipv_bloodpressure_high = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN30));
			this.fipv_bloodpressure_low = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN31));
			this.fipv_has_heart_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN32));
			this.fipv_heart_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN33));
			this.fipv_has_lung_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN34));
			this.fipv_lung_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN35));
			this.fipv_has_vulva_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN36));
			this.fipv_vulva_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN37));
			this.fipv_has_vagina_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN38));
			this.fipv_vagina_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN39));
			this.fipv_has_cervix_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN40));
			this.fipv_cervix_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN41));
			this.fipv_has_uterus_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN42));
			this.fipv_uterus_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN43));
			this.fipv_has_appendix_abnormal = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN44));
			this.fipv_appendix_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN45));
			this.fipv_hemoglobin = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN46));
			this.fipv_wbc = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN47));
			this.fipv_blood_platelet = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN48));
			this.fipv_blood_other = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN49));
			this.fipv_pro = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN50));
			this.fipv_glu = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN51));
			this.fipv_urine_ketone = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN52));
			this.fipv_bld = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN53));
			this.fipv_urine_other = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN54));
			this.fipv_blood_type = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN55));
			this.fipv_blood_rh = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN56));
			this.fipv_bs = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN57));
			this.fipv_serum_cpt = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN58));
			this.fipv_serum_ast = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN59));
			this.fipv_blood_protein = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN60));
			this.fipv_tbil = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN61));
			this.fipv_dbil = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN62));
			this.fipv_serum_creatinine = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN63));
			this.fipv_bun = cursor.getFloat(cursor.getColumnIndex(FIPV_COLUMN64));
			this.fipv_vaginal_discharge = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN65));
			this.fipv_vaginal_other_discharge = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN66));
			this.fipv_vagina_cleanness = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN67));
			this.fipv_surface_antigen = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN68));
			this.fipv_surface_antibody = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN69));
			this.fipv_e_antigen = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN70));
			this.fipv_e_antibody = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN71));
			this.fipv_core_antibody = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN72));
			this.fipv_syphilis_sero_test = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN73));
			this.fipv_hiv_test = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN74));
			this.fipv_brightness_mode = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN75));
			this.fipv_overall_access = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN76));
			this.fipv_overall_access_abnormal = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN77));
			this.fipv_healthguide = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN78));
			this.fipv_healthguide_other = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN79));
			this.fipv_need_transfer = cursor.getInt(cursor.getColumnIndex(FIPV_COLUMN80));
			this.fipv_transfer_reason = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN81));
			this.fipv_transfer_hospital = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN82));
			this.fipv_next_visit_date = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN83));
			this.fipv_doctor = cursor.getString(cursor.getColumnIndex(FIPV_COLUMN84));
			 
		}
		cursor.close();
	}
	
	public void updateFirstPrenatalVisit(int id){
		ContentValues value = new ContentValues();
		value.put(FIPV_COLUMN1, this.getFipv_id());
		value.put(FIPV_COLUMN2, this.getFipv_date());
		value.put(FIPV_COLUMN3, this.getFipv_preg_week());
		value.put(FIPV_COLUMN4, this.getFipv_age());
		value.put(FIPV_COLUMN5, this.getFipv_husband_name());
		value.put(FIPV_COLUMN6, this.getFipv_husband_age());
		value.put(FIPV_COLUMN7, this.getFipv_husband_phone());
		value.put(FIPV_COLUMN8, this.getFipv_gravidity());
		value.put(FIPV_COLUMN9, this.getFipv_vaginal_delivery_times());
		value.put(FIPV_COLUMN10, this.getFipv_cesarean_section_times());
		value.put(FIPV_COLUMN11, this.getFipv_last_menses());
		value.put(FIPV_COLUMN12, this.getFipv_last_menses_date());
		value.put(FIPV_COLUMN13, this.getFipv_ycq());
		value.put(FIPV_COLUMN14, this.getFipv_past_history());
		value.put(FIPV_COLUMN15, this.getFipv_past_history_other());
		value.put(FIPV_COLUMN16, this.getFipv_family());
		value.put(FIPV_COLUMN17, this.getFipv_family_other());
		value.put(FIPV_COLUMN18, this.getFipv_personal());
		value.put(FIPV_COLUMN19, this.getFipv_personal_other());
		value.put(FIPV_COLUMN20, this.getFipv_has_gyneopration());
		value.put(FIPV_COLUMN21, this.getFipv_gyneopration());
		value.put(FIPV_COLUMN85, this.getFipv_pregnance_history());
		value.put(FIPV_COLUMN22, this.getFipv_miscarry());
		value.put(FIPV_COLUMN23, this.getFipv_dying_fetus());
		value.put(FIPV_COLUMN24, this.getFipv_stillbirth());
		value.put(FIPV_COLUMN25, this.getFipv_neonatal_death());
		value.put(FIPV_COLUMN26, this.getFipv_birth_defect());
		value.put(FIPV_COLUMN27, this.getFipv_height());
		value.put(FIPV_COLUMN28, this.getFipv_weight());
		value.put(FIPV_COLUMN29, this.getFipv_bmt());
		value.put(FIPV_COLUMN30, this.getFipv_bloodpressure_high());
		value.put(FIPV_COLUMN31, this.getFipv_bloodpressure_low());
		value.put(FIPV_COLUMN32, this.getFipv_has_heart_abnormal());
		value.put(FIPV_COLUMN33, this.getFipv_heart_abnormal());
		value.put(FIPV_COLUMN34, this.getFipv_has_lung_abnormal());
		value.put(FIPV_COLUMN35, this.getFipv_lung_abnormal());
		value.put(FIPV_COLUMN36, this.getFipv_has_vulva_abnormal());
		value.put(FIPV_COLUMN37, this.getFipv_vulva_abnormal());
		value.put(FIPV_COLUMN38, this.getFipv_has_vagina_abnormal());
		value.put(FIPV_COLUMN39, this.getFipv_vagina_abnormal());
		value.put(FIPV_COLUMN40, this.getFipv_has_cervix_abnormal());
		value.put(FIPV_COLUMN41, this.getFipv_cervix_abnormal());
		value.put(FIPV_COLUMN42, this.getFipv_has_uterus_abnormal());
		value.put(FIPV_COLUMN43, this.getFipv_uterus_abnormal());
		value.put(FIPV_COLUMN44, this.getFipv_has_appendix_abnormal());
		value.put(FIPV_COLUMN45, this.getFipv_appendix_abnormal());
		value.put(FIPV_COLUMN46, this.getFipv_hemoglobin());
		value.put(FIPV_COLUMN47, this.getFipv_wbc());
		value.put(FIPV_COLUMN48, this.getFipv_blood_platelet());
		value.put(FIPV_COLUMN49, this.getFipv_blood_other());
		value.put(FIPV_COLUMN50, this.getFipv_pro());
		value.put(FIPV_COLUMN51, this.getFipv_glu());
		value.put(FIPV_COLUMN52, this.getFipv_urine_ketone());
		value.put(FIPV_COLUMN53, this.getFipv_bld());
		value.put(FIPV_COLUMN54, this.getFipv_urine_other());
		value.put(FIPV_COLUMN55, this.getFipv_blood_type());
		value.put(FIPV_COLUMN56, this.getFipv_blood_rh());
		value.put(FIPV_COLUMN57, this.getFipv_bs());
		value.put(FIPV_COLUMN58, this.getFipv_serum_cpt());
		value.put(FIPV_COLUMN59, this.getFipv_serum_ast());
		value.put(FIPV_COLUMN60, this.getFipv_blood_protein());
		value.put(FIPV_COLUMN61, this.getFipv_tbil());
		value.put(FIPV_COLUMN62, this.getFipv_dbil());
		value.put(FIPV_COLUMN63, this.getFipv_serum_creatinine());
		value.put(FIPV_COLUMN64, this.getFipv_bun());
		value.put(FIPV_COLUMN65, this.getFipv_vaginal_discharge());
		value.put(FIPV_COLUMN66, this.getFipv_vaginal_other_discharge());
		value.put(FIPV_COLUMN67, this.getFipv_vagina_cleanness());
		value.put(FIPV_COLUMN68, this.getFipv_surface_antigen());
		value.put(FIPV_COLUMN69, this.getFipv_surface_antibody());
		value.put(FIPV_COLUMN70, this.getFipv_e_antigen());
		value.put(FIPV_COLUMN71, this.getFipv_e_antibody());
		value.put(FIPV_COLUMN72, this.getFipv_core_antibody());
		value.put(FIPV_COLUMN73, this.getFipv_syphilis_sero_test());
		value.put(FIPV_COLUMN74, this.getFipv_hiv_test());
		value.put(FIPV_COLUMN75, this.getFipv_brightness_mode());
		value.put(FIPV_COLUMN76, this.getFipv_overall_access());
		value.put(FIPV_COLUMN77, this.getFipv_overall_access_abnormal());
		value.put(FIPV_COLUMN78, this.getFipv_healthguide());
		value.put(FIPV_COLUMN79, this.getFipv_healthguide_other());
		value.put(FIPV_COLUMN80, this.getFipv_need_transfer());
		value.put(FIPV_COLUMN81, this.getFipv_transfer_reason());
		value.put(FIPV_COLUMN82, this.getFipv_transfer_hospital());
		value.put(FIPV_COLUMN83, this.getFipv_next_visit_date());
		value.put(FIPV_COLUMN84, this.getFipv_doctor());
		
		String where = FIPV_COLUMN1 + "=" + id + " ";
		mContext.getContentResolver().update(CONTENT_URI_TB16, value, where, null);
		
	}
	
	public void delectFirstPrenatalVisit(int id){
		String where = FIPV_COLUMN1 + "=" + id + " ";
		mContext.getContentResolver().delete(CONTENT_URI_TB16, where, null);
		
	}

}
